To access the data for the paper "Who Creates Jobs?  Small vs. Large vs. Young" a researcher must
apply to the U.S. Census Bureau.  The Center for Economic Studies operates 15 Research Data Centers (RDC) around the
country for such data access.  The procedures for such access are provided at:

http://www.census.gov/ces/rdcresearch/index.html

The data used in this project are archived for available use by RDCs.  Two core micro level datasets are used in the
analysis:  jcr_firms.sas7bdat and jcr_estabs.sas7bdat.  They are archived in the directory:  /projects4/arts422/size_age/RESTAT_archive.
There are other derivative datasets (based on these two core datasets) that are also archived there.

When possible we've made public use discloseable versions of the confidential datasets used in the paper available with this packet.



# #######################################################################################
# this code lists the programs that make the revised fully saturated version of the paper
# #######################################################################################

######################################
# firm results by firm characteristics
######################################

##############################
# create Table 1 and figure 1
##############################

* Table 1 is directly from the BDS 2005 data. Current public version of BDS available at http://www.census.gov/ces/dataproducts/bds/index.html
* Figure 1 is an aggregation of the internal (non disclosed) version of the same BDS 2005 data (years  1992-2005). 
* FIGURE1 available in MS14204_FIG1.XLS.
* Figure 1 is generated by Figure1.sas. The code makes use of the internal (non disclosed) versions of the BDS2005 table. The disclosed (post cell supression) archived version is provided in this packet. Statistics produced with this version are very similar (up to the 3rd/4th decimal).
* Archived versions of the BDS are available from the Census Bureau by using the "BDS Team" contact information at: http://www.census.gov/ces/dataproducts/bds/

 
############################################################################################
# create figure 2A and 2B,3, 4A and 4B, 5 
# saturated, one ways, two-ways, partials without indx yr effects
# These figures are created directly from output from the following code:
############################################################################################

* saturated_model.sas;   * Creates results based on average DHS size class methodology;
* saturated_model_i.sas; * Creates results based on initial size class methodology;
 

#############################################
# Create Figure 6
# Employment Weighted Startup Rates by Sector
#############################################

asp_prelim_92_05_firm0_sector.sas;

################################################################################
# Create Figure 7
# now results without ind year by sector
# These figures are created directly from output from the following code:
################################################################################

saturated_model_s.sas; * Creates results based on average DHS size class methodology;


##########################################
#  estab results with firm characteristics
##########################################
###################################
# Figures 8 and 9
# results without ind year
###################################

saturated_model_e.sas;
saturated_model_ei.sas;

##########################################
#  WEB APPENDIX
##########################################

###################################
# Figure W1
###################################

This figure is illustrative and created from made up data

###################################
# Figures W2 AND W3
###################################

growth_dist_firm.sas  * firm based employment growth distributions weighted and unweighted.  Fig. W2
growth_dist.sas       * estab based employment growth distributions weighted and unweighted. Fig. W2
                      * code also includes growth correlations. Fig W3.

##########################################################################
# Robustness tests: 
##########################################################################
##########################################################################
# Estab results with hybrid characteristics (firm size, estab age)
##########################################################################
###################################
# Figure W4
###################################

saturated_model_ef_chars.sas;  * Creates results based on average DHS size class methodology;
saturated_model_efi_chars.sas; * Creates results based on initial size class methodology;

##########################################################################
# Include only firms less than 500 employees 
##########################################################################
###################################
# Figure W5, W6.1A, W6.1B
###################################

sas asp_prelim_92_05_firm0_l500.sas;        * Creates results based on average DHS size class methodology;
sas asp_prelim_92_05_initszfirm0_l500.sas ; * Creates results based on initial size class methodology;
sas asp_prelim_92_05_firm0c_l500.sas;       * Creates results for continuers only;

##########################################################################
# ADDITIONAL RESULTS 
##########################################################################
##########################################################################
# Figure W6.2A, W6.2B 
# Figure W7 
# Figure W10, W11: top pannels 
# Figure W12A and W12B 
# Figure W13 
# Figure W14A AND W14B 
# Figure W15 
# Figures W16-W23 
# TABLE W2
# NOTE: THIS IS SAME CODE THAT GENEREATE FIGS 2A and 2B,3 4A and 4B, 5 
##########################################################################

saturated_model.sas;   * Creates results based on average DHS size class methodology;
saturated_model_i.sas; * Creates results based on initial size class methodology;

##########################################################################
# Figure W8A, W8B 
# Figure W9A, W9B 
# Figure W10, W11: bottom pannels 
# NOTE: THIS IS SAME CODE THAT GENEREATE FIGS 8 AND 9 IN MAIN BODY OF TEXT 
##########################################################################

saturated_model_e.sas;
saturated_model_ei.sas;

##########################################################################################
# saturated, one ways, two-ways, partials with indx yr effects
# Figure W24A, W24B, W25, W26A, W26B, W27 
# equivalent to FIGS 2A and 2B,3 4A and 4B, 5 controlling for industry year effects
##########################################################################################

saturated_model_indxyr.sas;    * Creates results based on average DHS size class methodology;
saturated_model_indxyr_i.sas;  * Creates results based on initial size class methodology;

##########################################################################################
# TABLE W1
##########################################################################################

SOURCES LISTED ON THE TABLE.